package com.gcloud.persistance;

public class Querys {

	public static final String createTableIndex = "CREATE TABLE INDEX_FILE_SERVICE  ("
			+ "KEY  TEXT(100) PRIMARY KEY NOT NULL,"
			+ "NAME TEXT(100),"
			+ "DESCRIPTION TEXT(100),"
			+ "MIMETYPE  TEXT(50),"
			+ "ACCOUNT  TEXT(100),"
			+ "URI TEXT(100),"
			+ "SERVICE TEXT(100),"
			+ "SIZE INT(20),"
			+ "IS_DIRECTORY INT(1),"
			+ "IS_FAVORITE INT(100),"
			+ "PARENT TEXT(100),"
			+ "THUMBNAIL BLOB,"
			+ "IS_ROOT INT(1)" + ");";

	public static final String createAccountTable = "CREATE TABLE ACCOUNT  ("
			+ "ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"
			+ "SERVICE TEXT(50)," + "ACCOUNT TEXT(50)," + "KEY  TEXT(100),"
			+ "KEY_SECRET  TEXT(100)," + "ACTIVE  INTEGER(1)" + ");";

	public static final String createPlayTable = "create table play (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, GAME TEXT(50));";

	public static final String getFilesFromDropBox = "SELECT * FROM INDEX_FILE_SERVICE WHERE PARENT LIKE ?";

	public static final String getFilesFromGoogleDrive = "";

}
